ItemChoice

Entity Definition

Logical Name : ItemChoice
Physical Name : CO_CHC_ITM

A mapping from a parent GroupSelectItem to Item denoting one of the choices that may be made by the customer at the time of sale.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) GroupSelectItem(AS_ITM_GP_SEL)
MemberItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM_MBR IdentityUUID char(32) Item(AS_ITM)

Relationships

Parent Entity Verb Phrase Child Entity
Item is part of ItemChoice
GroupSelectItem is a selection group of ItemChoice

Logical Views containing ItemChoice

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View